<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="typingorderlist.aspx.cs" Inherits="sow.typingorderlist" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Text="Writing"></asp:Label>
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="ObjectDataSource2"
            DataTextField="Title" DataValueField="WritingID" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
        </asp:DropDownList><asp:ObjectDataSource ID="ObjectDataSource2" runat="server" DeleteMethod="Delete"
            InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
            TypeName="server.TypingServiceDataSetTableAdapters.WritingTableAdapter" UpdateMethod="Update">
            <DeleteParameters>
                <asp:Parameter Name="Original_WritingID" Type="Decimal" />
                <asp:Parameter Name="Original_AuthorID" Type="Decimal" />
                <asp:Parameter Name="Original_Title" Type="String" />
                <asp:Parameter Name="Original_CategoryID" Type="Int32" />
                <asp:Parameter Name="Original_SourcePostID" Type="Int32" />
                <asp:Parameter Name="Original_ResultPostID" Type="Int32" />
                <asp:Parameter Name="Original_ReceiveDate" Type="DateTime" />
                <asp:Parameter Name="Original_Desc1" Type="String" />
                <asp:Parameter Name="Original_Desc2" Type="String" />
                <asp:Parameter Name="Original_Desc3" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="AuthorID" Type="Decimal" />
                <asp:Parameter Name="Title" Type="String" />
                <asp:Parameter Name="CategoryID" Type="Int32" />
                <asp:Parameter Name="SourcePostID" Type="Int32" />
                <asp:Parameter Name="ResultPostID" Type="Int32" />
                <asp:Parameter Name="ReceiveDate" Type="DateTime" />
                <asp:Parameter Name="Desc1" Type="String" />
                <asp:Parameter Name="Desc2" Type="String" />
                <asp:Parameter Name="Desc3" Type="String" />
                <asp:Parameter Name="Original_WritingID" Type="Decimal" />
                <asp:Parameter Name="Original_AuthorID" Type="Decimal" />
                <asp:Parameter Name="Original_Title" Type="String" />
                <asp:Parameter Name="Original_CategoryID" Type="Int32" />
                <asp:Parameter Name="Original_SourcePostID" Type="Int32" />
                <asp:Parameter Name="Original_ResultPostID" Type="Int32" />
                <asp:Parameter Name="Original_ReceiveDate" Type="DateTime" />
                <asp:Parameter Name="Original_Desc1" Type="String" />
                <asp:Parameter Name="Original_Desc2" Type="String" />
                <asp:Parameter Name="Original_Desc3" Type="String" />
                <asp:Parameter Name="WritingID" Type="Decimal" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="AuthorID" Type="Decimal" />
                <asp:Parameter Name="Title" Type="String" />
                <asp:Parameter Name="CategoryID" Type="Int32" />
                <asp:Parameter Name="SourcePostID" Type="Int32" />
                <asp:Parameter Name="ResultPostID" Type="Int32" />
                <asp:Parameter Name="ReceiveDate" Type="DateTime" />
                <asp:Parameter Name="Desc1" Type="String" />
                <asp:Parameter Name="Desc2" Type="String" />
                <asp:Parameter Name="Desc3" Type="String" />
            </InsertParameters>
        </asp:ObjectDataSource>
        <asp:Label ID="Label2" runat="server" Text=".                Status"></asp:Label>
        <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="ObjectDataSource3"
            DataTextField="Status" DataValueField="StatusID">
        </asp:DropDownList><asp:ObjectDataSource ID="ObjectDataSource3" runat="server" DeleteMethod="Delete"
            InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
            TypeName="server.TypingServiceDataSetTableAdapters.StatusLookUpTableAdapter"
            UpdateMethod="Update">
            <DeleteParameters>
                <asp:Parameter Name="Original_Status" Type="String" />
                <asp:Parameter Name="Original_StatusID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="Status" Type="String" />
                <asp:Parameter Name="Original_Status" Type="String" />
                <asp:Parameter Name="Original_StatusID" Type="Int32" />
                <asp:Parameter Name="StatusID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="Status" Type="String" />
            </InsertParameters>
        </asp:ObjectDataSource>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" DataKeyNames="WritingOrderID" DataSourceID="ObjectDataSource1">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:BoundField DataField="WritingOrderID" HeaderText="WOID" InsertVisible="False"
                    ReadOnly="True" SortExpression="WritingOrderID" />
                <asp:BoundField DataField="WritingID" HeaderText="WritingID" SortExpression="WritingID" />
                <asp:BoundField DataField="StatusID" HeaderText="StatusID" SortExpression="StatusID" />
                <asp:BoundField DataField="Comment" HeaderText="Comment" SortExpression="Comment" />
                <asp:BoundField DataField="WorkerID" HeaderText="WorkerID" SortExpression="WorkerID" />
                <asp:BoundField DataField="ModifyDate" HeaderText="ModifyDate" SortExpression="ModifyDate" />
            </Columns>
        </asp:GridView>
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
            InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetDataByWritingID"
            TypeName="server.TypingServiceDataSetTableAdapters.WritingOrderTableAdapter">
            <InsertParameters>
                <asp:Parameter Name="WritingID" Type="Decimal" />
                <asp:Parameter Name="StatusID" Type="Int32" />
                <asp:Parameter Name="Comment" Type="String" />
                <asp:Parameter Name="WorkerID" Type="Int32" />
                <asp:Parameter Name="ModifyDate" Type="DateTime" />
            </InsertParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" DefaultValue="1" Name="WRID" PropertyName="SelectedValue"
                    Type="Decimal" />
            </SelectParameters>
        </asp:ObjectDataSource>
    
    </div>
    </form>
</body>
</html>
